google apps script - Updating a field based on contents on another tab -


I have created a spreadsheet with several tabs.

The column 'id' and 'name' in my 'source' tab 1 have 'id' in my 'target' tab 2.

I am trying to iterate through rows in my Target tab and read the value of the ID and then search my source tab. Id. When I get the ID, I want to capture the value in the 'Name' field and I want to add it to a cell on the same line of ID of my Target tab.

I have a difficult time getting rid of the logic through an array and I'm getting the value in an array of the contents of the target tab or the target tab. In the Targets tab, there can be more than one instance of an ID, and I have to update them all.

Any suggestions will be welcome!

Here's a suggestion: 

  / * Tell us source name With array (column A) & amp; The ID (column B) array is the 'source' and the target array in which the ID array is the 'target', you get it with something like * / var source = SpreadsheetApp.getActiveSpreadsheet (). GetSheets () [0] .getDataRange () GetValues ​​(); // and var target = SpreadsheetApp.getActiveSpreadsheet (). GetSheets () [1] .getDataRange () GetValues ​​(); // If the other column, change the index values ​​in the array: 0 = A, 1 = B ... // Then create a third array, which will be the new target with the ID + names, and it will be 'newtarget' var newtarget = New Array () / call for I / L: i = 0; I & lt; Target.length; ++ i) {// (J = 0; J.L.L.; Source.Lamp; ++ J) does not remember any ID. I 0] .trastering (). Match (source [j] [1] .stisting ()) == source [ja] [1] .ststring ()) {var newtargetrow = [source [ja] [0], target [i] [0]] / / If the match was found, the name (idx0) and id (idx1)} and {var newtargetrow = ['no name found', target [i] [0]] // if not found match, in column of name Show} newtarget.push (newtargetrow); // store results in new array with 2 columns} // loop source} // loop targets * * Now you have a new target array that can directly overwrite the old target SetValues ​​() * / Var sh = SpreadsheetApp.getActiveSpreadsh using Asset () GetSheets () [1]; // Target sheet as NR2 S.ZRRZ (1, newtabg.length, newtagues [0]. Length) .Setwolves (newtag); //   
 Note that I did not test this code but it should give you a starting point I have compared it with a string, but you have other comparisons (direct parallel between array elements ) ... If you are in danger of unwanted spaces in sheet data then you can also remove spaces in the id ... I do not know your data, so it is up to you.

Comments

Post a Comment

Popular posts from this blog

Python SQLAlchemy：AttributeError: Neither 'Column' object nor 'Comparator' object has an attribute 'schema' -

I tried to create a new database in my project, but when I run the script, I get this error, I have another project, this type of definition worked before, but now it gets a single error. I am using Python 2.7.8 and the version of SQLAlchemy module is 0.9.8. By the way, using a project flask- SQLAlchemy, it works well, I'm confused. Traceback information is as follows: Traceback (most recent call final): File "D: / Projects / IOM / db_create.py", line 4, & lt; Module & gt; From the models the base file "D: \ Projects \ OO-IM \ models.py", in line 15, in the & lt; Module & gt; Column ( 'followed_id', int (), ForeignKey ( 'user.id')) file "C: \ Python27 \ lib \ site-packages \ SQLAlchemy \ SQL \ schema.py", line 369, __new__ schema = metadata. Schema file "C: \ Python27 \ lib \ site-packages \ SQLAlchemy \ SQL \ elements.py", line 662, AttributeError in __getattr__ key): Neither 'column' object nor ...
Read more

java - How not to audit a join table and related entities using Hibernate Envers? -

I use Eners to be hibernate to audit my institutions. I have an audit entity, Foo , which includes a list & lt; Bars & gt; However, I do not want to audit the bar institutions, in the form of properties, I have written that: @inti @edicated public class Foo {@JoinTable (name = "T_FOO_BAR", joinColumns = @JoinColumn (name = "FOO_ID"), inverseJoinColumns = @JoinColumn (Name = "BAR_ID")) @ManyToMany (Cascade = Persist) @ Indited (targetAuditMode = RelationTargetAuditMode.NOT_AUDITED ) Public listing & lt; Bars & gt; GetBars () {Return bars; }} Now, I want to retrieve an amendment of foo : AuditReader reader = AuditReaderFactory.get (GetEntityManager ()); FU modification = (FU) reader.CreativeTeA () .entensEtrevision (Foo Class, 42) .getSingleResult (); Unfortunately, when I want to retrieve all the data (i.e. when it loads lazy times ), error me ORA-00942: table or view is not present , because Tried to query this: Sel...
Read more

mongodb - CakePHP paginator ignoring order, but only for certain values -

While pagging my user model in kppp, I can sort with some values, but not others. For example, I can order results from created or email , for example, but username or reputation seems to come back order by arbitrary command for example with a list of users: $ this-> paginate = array ('condition' => array ( 'User.is_active' = & gt; true), 'border' => 24, 'order' => array ('User.created' => DESC)); Works as expected, but $ this - & gt; Paged = array ('conditions' = & gt; array (' user.isIactive '= & gt; true),' border '= & gt; 24,' command '= & gt; array (' user repeats' = ' & Gt; DESC ')); No, no. I first thought that this could be a database issue, but when I search the database directly, sorted as expected. Note: I am using Mangodebi with the Mongo DB plugin of Ichikawa for the KPPHP; Pagnetizing users are used to work properl...
Read more