Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Can we use the synthesized fields to create few more fields during the same load operation from a select query

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,

3 Replies
Not applicable
Author

Quite did not get your question, but Yes you can create few more fields.

Can you attach the sample app for the same?

Anonymous
Not applicable
Author

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 ....;

jagan
Luminary Alumni
Luminary Alumni

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.