Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I need your help to suggest for the below data fetching issue.
I have excel sheets with same column names and difference in Budget .when loading the tables the columns are auto concatenating and giving me the summed value in UI .I want to show the individual values from each sheet How to achieve this.
Example: 1st sheet my whole value is 5500
2nd sheet the whole value is 7500
In qlik it is showing 13000.I want to show 5500 and 7500
Hi,
You can do is create a flag in both the table like
table_1:
load *,
1 as sheetflag
from sheet1;
concatenate
load *,
2 as sheetflag
from sheet2;
and if you dont want the tables to get concatenated then you can use Noconcatenate functionality of considering both the tables different. script would go like this.
table_1:
load * from sheet1;
Noconcatenate
table_2:
load * from sheet2;
Regards,
Prashant
Hi Prashant,
Thank you very much for your reply.I am using cross table in my load script because my excel is in pivot format and contains Actual and Unpaid sales over month.
Hi,
can you provide some dummy data so i can help you out with it.
Regards,
Prashant
Hi Prashant,
Please find attached sample excel. My requirement is to load all the sheets from the excel and display the budget values based on the project. The data has to choose based on the project name of the sheet(sheet name)
Hi,
In the attached data which value you are assuming(Total expenditure, Budgeted Value) which you want to display in UI?
Thanks