Combine 2 source into 1 by same field

[Tang23]

Hello all,

I have to upload 2 sourcing files, one sourcing file's field name is: Senario Year Pillar Nameplate period Type Value; the other sourcing file's field name is :Senario Year View Period Pillar Source Nameplate Incomestatement Value.

I want to combine those 2 files into 1 file by the same fields: Senario Year Period Pillar .

Could you please help me?

[micheledenardi]

hi,

is not very clear the files structure but you can try something like this:

FinalTable:
Load 
   [Senario Year Period Pillar],
   [...]
From File1.xslx...;

Concantenate(FinalTable)
Load 
   [Senario Year Period Pillar],
   [...]
From File2.xslx...;

[Tang23]

It works , many thank!

 I have another question, both 2 files have same-named field "Value", but in first file it shows " Incomestatement" field data, in second field it shows "Type" data, so how can I combine 2 files and not mess with the data

[micheledenardi]

use "AS" statement to rename fields in order to normalize your data sources fields name:

FinalTable:
Load 
   [Senario Year Period Pillar],
   [Incomestatement] as Value,
   [...]
From File1.xslx...;

Concantenate(FinalTable)
Load 
   [Senario Year Period Pillar],
   [Type] as Value,
   [...]
From File2.xslx...;