topic Script Help in QlikView

Script Help

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

Can you help me connect these tables correctly with a script?

I have 5 Tables, I need the to keep all of the information on table 1 and if the other tables have table 1 information for the other columns in the tables I need to pull that information.

Table 1

order Number

Carton Number

Sku

Table 2

Order Header Key

Order number

Sku

Return number

Order Amount

Order Date

Table 3

Order Header Key

Order number

Sku

Appt Date

Table 4

WO Key

Order number

Sku

WO number

WO Status

Table 5

WO key

Note Text

Contact User

Re: Script Help

juraj_misina — Wed, 28 Nov 2018 21:43:43 GMT

Have a look at Exists() function here

Table 1
order Number
Carton Number
Sku

Table 2
Order Header Key
Order number
Sku
Return number
Order Amount
Order Date
Where Exists ([Order Number])

Table 3
Order Header Key
Order number
Sku 
Appt Date
Where Exists ([Order Number])

Table 4
WO Key
Order number
Sku
WO number
WO Status
Where Exists ([Order Number])

Table 5
WO key
Note Text
Contact User
Where Exists([WO key])

Hope this helps.

Juraj

Re: Script Help

clsaulsberry — Wed, 28 Nov 2018 23:32:34 GMT

Thank you that was helpful