Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
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
Highlighted
Not applicable

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

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

Can you attach the sample app for the same?

Highlighted
Honored Contributor

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

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

MVP & Luminary
MVP & Luminary

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

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.