in reply to Unable to compare 2 arrays from 2 separate columns of separate sheets.
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^2: Unable to compare 2 arrays from 2 separate columns of separate sheets.
by chandantul (Scribe) on Feb 09, 2021 at 17:53 UTC | |
Thanks! Can you please check my code snippet and let me know the exact issue while updating unique values after comparison or where i am doing wrong here?
| [reply] [d/l] |
by choroba (Cardinal) on Feb 09, 2021 at 20:05 UTC | |
and another called syslog_-prod containing Running the edited code Read more... (2 kB) I got no errors nor warnings and the output file was created with a coloured header and the following contents in the first column: but formatted as 1.23E+08. Sorry, what was your question again?
map{substr$_->[0],$_->[1]||0,1}[\*||{},3],[[]],[ref qr-1,-,-1],[{}],[sub{}^*ARGV,3]
| [reply] [d/l] [select] |
by chandantul (Scribe) on Feb 10, 2021 at 05:18 UTC | |
The infinity loop for the below comparison code is my issue. The ADdata sheet first column contain 1-30000 users data and prod_log sheet contain around 501 entries of users those are Nonunique . I will need to collect unique entries from prod_log first column and compare against ADdata sheet first column and update the existing entries of the same file and update the match to other file. The above code seems to be not working. need some suggestion or code snippet.
| [reply] [d/l] |
by chandantul (Scribe) on Feb 11, 2021 at 16:45 UTC |