Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Sxbbb
Creator III
Creator III

I want add Value '0' to SampleNo .

I use code

Suchanan_0-1675736006102.png

result

Suchanan_1-1675736054722.png

This is Field SampleNo 

Suchanan_2-1675736152773.png

I want add Value '0' to SampleNo and 

Bring workoder to connect SampleNo which has added 0 .
I use the code but it gives error.

Suchanan_3-1675736978029.png

 

 

 

17 Replies
Sxbbb
Creator III
Creator III
Author

I try Code but it error 

Suchanan_0-1675738905756.png

 

MayilVahanan

Are you looking to display Zero when SampleNo is blank? If so, try like below..


=WorkOrder&'-'&Alt(SampleNo,0)

 

If not, can you elaborate your requirement in detail?

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Sxbbb
Creator III
Creator III
Author

Want WorkOrder&'-'&0 to divide WorkOrder into each WorkOrder.
for example WorkOrder&'-'&SampleNo
11111-0
11111-1
11111-5
11111-7
11111-8
22222-0
22222-1
22222-3
22222-5
33333-0
33333-1
33333-2
33333-3
but SampleNo not have Value '0'

Suchanan_0-1675741289574.png

 

 
Sxbbb
Creator III
Creator III
Author

Require WorkOrder&'-'&0 to split each next WorkOrder. 

by value
WorkOrder&'-'&0 equals 0
MayilVahanan

Try like below

Load * Inline
[
Dim
1
2
];

Calculated Dim:

=if(Dim = 1, [WorkOrder] &'-'& SampleNo, [WorkOrder]&'-'&0)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Sxbbb
Creator III
Creator III
Author

Result  

Suchanan_0-1675743324162.png

 

barnabyd
Partner - Creator III
Partner - Creator III

I think this is what you're looking for ...

=WorkOrder&'-'&num(SampleNo,'0#')
Barnaby Dunn
BI Consultant
Sxbbb
Creator III
Creator III
Author

I would like

Suchanan_2-1675743715015.png

 

barnabyd
Partner - Creator III
Partner - Creator III

What are the input values? I.e. what are the values of WorkOrder and SampleNo for each of these rows?

Barnaby Dunn
BI Consultant