topic Re: Creating a new field from fields that exist in the script in App Development

Creating a new field from fields that exist in the script

somthingmendi123 — Tue, 16 May 2023 12:07:36 GMT

if i want to bring several fields from different files what should i do?
for example, i want field from sales and from items and from stock.
thanks for answer

Re: Creating a new field from fields that exist in the script

Kushal_Chawda — Tue, 16 May 2023 12:27:11 GMT

@somthingmendi123 I don't think your description is enough to answer your question. But with limited description I could think of joining tables when you want to bring fields from multiple tables.

Re: Creating a new field from fields that exist in the script

somthingmendi123 — Tue, 16 May 2023 12:33:00 GMT

If I want to fetch fields that exist in the script, I must make a resident, but since I want fields from different tables, I can't make a resident from one table

Re: Creating a new field from fields that exist in the script

somthingmendi123 — Tue, 16 May 2023 12:33:21 GMT

If I want to fetch fields that exist in the script, I must make a resident, but since I want fields from different tables, I can't make a resident from one table

Re: Creating a new field from fields that exist in the script

Kushal_Chawda — Tue, 16 May 2023 12:38:11 GMT

@somthingmendi123 you can join your tables taking residents from different table

combine:
LOAD Field1,
Key,
Field2
resident table1

join(combine)
LOAD Field3,
Key,
Field4
resident table2

Re: Creating a new field from fields that exist in the script

somthingmendi123 — Tue, 16 May 2023 13:05:38 GMT

Thanks for the response
I will explain myself better

I want to create one uniform table in the script from fields in different tables and do different aggregations on them
For example, I have fields from a sales table and fields from an inventory table
I don't want to do a join between them because it doesn't solve my problem. I want to bring them all into one table in the script [in data load editor] and in this table do invoice operations

Re: Creating a new field from fields that exist in the script

Kushal_Chawda — Tue, 16 May 2023 22:15:52 GMT

@somthingmendi123 I want to bring them all into one table in the script [in data load editor .How it will be possible to bring fields into one table without join?

Re: Creating a new field from fields that exist in the script

rwunderlich — Tue, 16 May 2023 22:30:37 GMT

See https://qlikviewcookbook.com/2020/03/creating-temporary-script-associations/ for some options.

-Rob