Getting Data In

I have to combine two csv files of the lookup?

chitreshakumar
Communicator

The field is having created date till some time in first file and after that duration i have the data in other csv file .How can I combine these files ?Each of the file is having one unique field values for one particular field .Just take it as field1

0 Karma
1 Solution

493669
Super Champion

hi,
Try this:

| inputlookup lookup1.csv |table field1| append [| inputlookup append=true lookup2.csv |table field1] | table field1

View solution in original post

493669
Super Champion

hi,
Try this:

| inputlookup lookup1.csv |table field1| append [| inputlookup append=true lookup2.csv |table field1] | table field1

View solution in original post

chitreshakumar
Communicator

Will that contain created date field along with field1.Or should I add
| inputlookup lookup1.csv |table field1,created_date| append [| inputlookup append=true lookup2.csv |table field1,created_date] | table field1,created_date

0 Karma

493669
Super Champion

yes you need to add
or try this also:

| inputlookup lookup1.csv | append [| inputlookup append=true lookup2.csv ] | table field1, created_date
0 Karma

chitreshakumar
Communicator

Ok Thanks!!

0 Karma
Did you miss .conf21 Virtual?

Good news! The event's keynotes and many of its breakout sessions are now available online, and still totally FREE!