Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sunil1989
Contributor
Contributor

Field Value to fetch the record??

Hi ,

Thanks in advance!!!

i am new to the qlik , this is my below script , for first row its work fine but when its go to the second row its able to fetch TableName(store_pick.Refunds ) but not able to fetch remaning row . please see below i have added log file can anyone please help me on this.

LIST_OF_TABLES:

LOAD * INLINE [

TableName,LoadType,StartDate,EndDate

store_pick.Payments,0,20170426,20170427

store_pick.Refunds,0,20170426,20170427

];

FOR i=1 to FieldValueCount('TableName')

LET vTableName = FieldValue('TableName',$(i)) ;

trace $(vTableName);

LET vLoadType = FieldValue('LoadType',$(i)) ;

trace $(vLoadType);

LET vStartDate = FieldValue('StartDate',$(i)) ;

trace $(vStartDate);

LET vEndDate = FieldValue('EndDate',$(i)) ;

trace $(vEndDate);

NEXT i

LOG FILE  ::

02/05/2017 07:19:17: 0030  LIST_OF_TABLES:

02/05/2017 07:19:17: 0031  LOAD * INLINE [

02/05/2017 07:19:17: 0032  TableName,LoadType,StartDate,EndDate

02/05/2017 07:19:17: 0033  store_pick.Payments,0,20170426,20170427

02/05/2017 07:19:17: 0034  store_pick.Refunds,0,20170426,20170427

02/05/2017 07:19:17: 0035  ]

02/05/2017 07:19:17:       4 fields found: TableName, LoadType, StartDate, EndDate, 2 lines fetched

02/05/2017 07:19:17: 0044  FOR i=1 to FieldValueCount('TableName')

02/05/2017 07:19:17: 0045    LET vTableName = FieldValue('TableName',1)

02/05/2017 07:19:17: 0046    trace store_pick.Payments

02/05/2017 07:19:17: 0046    store_pick.Payments

02/05/2017 07:19:17: 0047    LET vLoadType = FieldValue('LoadType',1)

02/05/2017 07:19:17: 0048    trace 0

02/05/2017 07:19:17: 0048    0

02/05/2017 07:19:17: 0050    LET vStartDate = FieldValue('StartDate',1)

02/05/2017 07:19:17: 0053    trace 20170426

02/05/2017 07:19:17: 0053    20170426

02/05/2017 07:19:17: 0054    LET vEndDate = FieldValue('EndDate',1)

02/05/2017 07:19:17: 0055    trace 20170427

02/05/2017 07:19:17: 0055    20170427

02/05/2017 07:19:17: 0093  NEXT i

02/05/2017 07:19:17: 0045    LET vTableName = FieldValue('TableName',2)

02/05/2017 07:19:17: 0046    trace store_pick.Refunds

02/05/2017 07:19:17: 0046    store_pick.Refunds

02/05/2017 07:19:17: 0047    LET vLoadType = FieldValue('LoadType',2)

02/05/2017 07:19:17: 0048    trace

02/05/2017 07:19:17: 0048  

02/05/2017 07:19:17: 0050    LET vStartDate = FieldValue('StartDate',2)

02/05/2017 07:19:17: 0053    trace

02/05/2017 07:19:17: 0053  

02/05/2017 07:19:17: 0054    LET vEndDate = FieldValue('EndDate',2)

02/05/2017 07:19:17: 0055    trace

02/05/2017 07:19:17: 0055  

02/05/2017 07:19:17: 0093  NEXT i

02/05/2017 07:19:18:      Execution finished.

2 Replies
Anil_Babu_Samineni

Seems, okay to me. You got two times trace as well. What was the issue?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
marcus_sommer

Please do not double-posting: Field Value to fetch the record??