Hello! I hope someone can help me on this. I want to add 2 fields in text and number format. However , I want the results in text format with leading 0 as shown below "Result" column...Thus, the results should be in Seq field format.
I tried Text(Num(Seq+counter,Repeat('0',Len(Seq)))) to no avail ...
Thank you in advance.
What is the problem with your expr? This is what i am getting when i use your expr?
LOAD *, Text(Num(Seq+counter, Repeat('0',Len(Seq)))) As Result INLINE [
Good solution, But why third one shows normally again ??
Your expression perfectly works until unless Unique Seq is not in the list. So, Could be issue over there. Let me recommend one person who is do some good job marcowedel