Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Add property to loaded data from csv file?

Hello,

I have two separate csv files that contain a list of [Account_name, Balance] for different time (2017 and 2018, respectfully).
However, the csv files themselves don't have the date mentioned anywhere.

How would I make so the data from the first file had "2017" date, and "2018" for the second?

How would I prevent data for the same account being overwritten?

So that I end up with something like this:

BalanceSomething else

2017

2018
AccountBalanceAccountBalance
some accountsome balancesame accountsome new balance

Thanks in advance!

0 Replies