Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

northenlight
New Contributor

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!