Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I had loaded a table into qlikview from a select query. While loading I have synthesized new fields from the existing fields of the table.
For eg:- Month(slice_date) Filled_Month.
salary+100 Increment_Sal. etc., wher slice_date,salary are the existing fields of the source table.
Now during the same load I intend to create few more fields like for eg:-
Increment_Sal*100 Bonus,
Num(Filled_Month) MonthNum etc,.
Can I do like this. If I can't do like this, then I need to once again write like below,
Num(Month(slice_date)) MonthNum etc,
Quite did not get your question, but Yes you can create few more fields.
Can you attach the sample app for the same?
Hi,
You can't reference a field that you create in a Load statement within the same Load statement.
For example if you create your Filled_Month statement, you can't use Filled_Month as input for a new field in the same load statement.
The easiest way to reference it is to add a preceding Load statement. This will allow you to reference the Filled_Month field.
Like:
Load
XYZ + 1 as ABC;
Load
1 as XYZ
From ....;
Hi,
Try like this
LOAD
*,
Month(slice_date) AS Filled_Month,
(salary+100) AS Increment_Sal,
(salary+100)*100 Bonus;
SELECT
*
FROM TableName;
Regards,
Jagan.