Data Loading

[Charmi]

Hello Team,

I have multiple excel files through which I want to load the data each excel files have different columns but only few column names are common. I want to create a story using these multiple excel files. How should I go about it?

Please help.

[JeanColeti]

There are manny ways to do this. If you explain better your data someone can tell the best way.

You can go into the script and do something like that.

Load

Fields excel 1

Concatenate

Load

Fields excel 2

Concatenate

Load

Fields excel 3....

So you'll connect the fields with the same name.

[Charmi]

Hello,

Thanks for the reply, so my column names are not exactly same, also no of columns in each excel sheet is different. I want to load different columns from different excel sheets where only few columns will be matching.

[JeanColeti]

Idk if I understand you, but this is not a problem.

See an example:

3 Excels, no of columns different, just a few columns matching.

Using concatenate you'll have some like that.

so, when you filter an ID for example, excel 1 and 2 will respond, excel 3 will not, because it don't have this column.

Is that you need?