topic Re: Field Name in QlikView

Field Name

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

ow to bring the field name of one table into anohter table

Detail there are 2 table name , Finance and Sales .

from sales table i want to take a field name " SaleDate" into Finance table .

and under Finace table i have Booking date .

AFter including SalesDate into FInance table , I want an field which will be (SaleDate-Booking Date )

Can someone guide me how do we get this ?

Thanks in advance

Re: Field Name

Anonymous — Wed, 21 Sep 2016 08:45:02 GMT

you may use a join, something like below

maybe you need to Format your fields

left join(Finance)

load

uniquekey,

SaleDate

resident Sales;

Tmp:

load *,

SalesDate-BookingDate as Days

resident Finance;

Re: Field Name

Anil_Babu_Samineni — Wed, 21 Sep 2016 08:49:21 GMT

Try With Mapping Prefix and ApplyMap

Re: Field Name

smilingjohn — Wed, 21 Sep 2016 08:51:54 GMT

Thanks Rudolph ,

Can you please tell me this in detail ?

Re: Field Name

smilingjohn — Wed, 21 Sep 2016 08:54:41 GMT

Rudolph i guess that u r trying to create new table from above script .

I want to include field of one table into another

Re: Field Name

Anonymous — Wed, 21 Sep 2016 09:12:21 GMT

to help you more in detail paste script of your tables

instead creating Tmp table you may also use directly.

left join(Finance)

load *,

SalesDate-BookingDate as Days

resident Finance;

Re: Field Name

Digvijay_Singh — Wed, 21 Sep 2016 09:17:56 GMT

If you have common key then Create mapping table after sales table load and before finance table load as -

salesdatemap:

Mapping load

ID, SaleDate

Resident Sales table;

Now while loading finance table use applymap to get saledate from map table-

applymap('salesdatemap',ID,'NA') as SaleDate;

If matching ID is not available in sales table then it will return NA if third parameter is used else ID will be returned for unmatched IDs.

Re: Field Name

jayaseelan — Wed, 21 Sep 2016 09:21:23 GMT

Hi john,

what is the link field you have between Finance and Sales tables.?

Using that you can use joins or applymap or keep concepts.

https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/Scripting/combine-tables-join-keep.htm

https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/Scripting/MappingFunctions/ApplyMap.htm

refer above links.

Hope will helps you

Thanks,