Write Range & Select in an input box

[gaurav2017]

Hi friends,

I am working with the range selection in an input box. While working I am facing some issue with different formats of value. While selecting "Numerical" values, my logic is working fine but when dealing with other type of formats like "text", My logic is not working. please help frnds.

Look for an attachment below.

Regards,

[gaurav2017]

Anybody please

[Josh_Good · Accepted solution]

The only solution I can think of would be to convert the letters into numbers.  You could create a new field in the data teh represents the data in numerical forms (using the ORD function) and then make a selection on that field.  One the selection is made on the new field you do could a select possible on the text field and unselect the numerical field.

[gaurav2017]

Hi Josh,

Thanks a lot..............I am curious....so i am asking a question. If one of the fields "Sel01", "Sel02", "Sel03" would be a Key then i have to put the logic in script for the occurence of it in every load statement or not.

regards,

[Josh_Good]

Hi,

If all of the uniquie key records exist in one of the tables then you can script the addional field into that table and leave it out of the other table(s).

If have unique key records in more than one table then best practice would be to write your script to get all the unique key records into one table first to avoid creating a synthetic key.

-Josh

[gaurav2017]

Dear,

Thanks for the reply.