Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Luminary
Luminary

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