Loading Different data from multiple folders

[qlikview979]

Hi Experts.

I have one folder  "DATA" in this folder  i have two sub folders like "2016_01_01",2016_01_02", in each sub folder having Same Excel file like "SALES".

in first sub folders Excel fields like

ID,NAME,AGE,SALES

in Second sub folders Excel fields like

ID,NAMES,AGE,SALES

In Two tables one field name is Different.

Here i Want to load Single load statement with two Excels data. With out using( "*" and "&" ) symbols.

is it possible in qlikview?

Regards

Mahesh

[tresesco]

Check these discussions :

Re: Load multiple xlsx files fromm multiple sub folders‌.

FileName in SubDirectories

Perhaps that would give you an idea.

[qlikview979]

Hi Bro,

please find the attached files.I tired , its reloaded successfully ,but  i am  getting blank.

please check with my source files.

Regards,

Mahesh

[qlikview979]

Hi Experts,

can any one help me ?

stalwar1‌kush141087‌swuehl‌gwassenaar‌jagan‌

Regards,

Mahesh

[effinty2112]

Hi Mahesh,

You could make a forced concatenation into a temporary table with fields

ID,NAME,NAMES,AGE,SALES

Where NAME is empty NAMES will have a value and vice versa.

Then you can make your table by loading from this resident table and either doing a string concatenation of NAME and NAMES or using a logic like if(IsNull(NAME),NAMES,NAME) as NAME.

Then drop your temporary table.

Cheers

Andrew

[qlikview979]

Hi Bro,

I want two tables data in Single load Statement.

Regards

[effinty2112]

Mahesh,

          Try this before you load the excel data:

FieldNameMap:

LOAD * INLINE [

    OldName, NewName

    NAMES, NAME

];

Rename Fields Using FieldNameMap;

[qlikview979]

Hi Bro,

can you share example with my data. i have attached my files in above.

Regards

[effinty2112]

HI Mahesh,

Regret I'm getting errors trying to unpack your rar file:

   1   LOADING DIFFERENT DATA FROM MULTIPLE SUB FOLDERS.rar: File "LOADING DIFFERENT DATA FROM MULTIPLE SUB FOLDERS\2016_01_01\SALES.xlsx" header broken

   2   LOADING DIFFERENT DATA FROM MULTIPLE SUB FOLDERS.rar: Unknown method in LOADING DIFFERENT DATA FROM MULTIPLE SUB FOLDERS\2016_01_01\SALES.xlsx

   3   LOADING DIFFERENT DATA FROM MULTIPLE SUB FOLDERS.rar: File "LOADING DIFFERENT DATA FROM MULTIPLE SUB FOLDERS\2016_01_02\SALES.xlsx" header broken

   4   LOADING DIFFERENT DATA FROM MULTIPLE SUB FOLDERS.rar: Unknown method in LOADING DIFFERENT DATA FROM MULTIPLE SUB FOLDERS\2016_01_02\SALES.xlsx

   5   LOADING DIFFERENT DATA FROM MULTIPLE SUB FOLDERS.rar: File "LOADING DIFFERENT DATA FROM MULTIPLE SUB FOLDERS\2016_01_01" header broken

   6   LOADING DIFFERENT DATA FROM MULTIPLE SUB FOLDERS.rar: File "LOADING DIFFERENT DATA FROM MULTIPLE SUB FOLDERS\2016_01_02" header broken

   7   LOADING DIFFERENT DATA FROM MULTIPLE SUB FOLDERS.rar: File "LOADING DIFFERENT DATA FROM MULTIPLE SUB FOLDERS" header broken

[qlikview979]

Hi Bro,

Please check now