Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
clsaulsberry
New Contributor III

Script Help

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

 

 

 

 

 

2 Replies
juraj_misina
Valued Contributor

Re: Script Help

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

clsaulsberry
New Contributor III

Re: Script Help

Thank you  that was helpful

Community Browser