Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
rahulsud007
Creator
Creator

Fieldvalue conversion

Hi guys, My input field is the following and

Input
IDMonth
Ak10101
AJ11111

I need output in following way. in

IDMonth
AK1
AK0
AK1
AK0
AK1
AJ1
aj1
aj1
aj1
aj1

Can anyone help me in this?

10 Replies
rahulsud007
Creator
Creator
Author

Hi guys, thanks for your support till now! Now here I have attached two more  field named Month1 and  Month2 along with Month.

But when I represent the data in Table Box I am getting blank spaces for Month and Month2 because its value is less than that of  Month1. I want to suppress those blank spaces and I need it in table box so the editing should be done in script. Can you guys help me in it?

Please check the attachment.

Thank you!