Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends
I have following sampae data in my data table. In my data load script I want to segregate codes with at least one letter Eg : 5KDIR,DIR22, SSDIR into category1 and Code with digits into category2. Kindly help me to write the syntax.
CODE | |
5KDIR | |
DIR22 | |
SSDIR | |
03456 | |
04190 | |
05012 | |
05742 |
If there is no possibility of no letters but special characters, you could easily get it like:
Load
If(IsNum(CODE), 2, 1) as Category
If there is no possibility of no letters but special characters, you could easily get it like:
Load
If(IsNum(CODE), 2, 1) as Category
Hi UPALI,
try this code in your load script for your requirement
Table:
load If(IsNum(CODE),CODE) as Category1,if(IsText(CODE),CODE) as Category2 ;
load * Inline [
CODE
5KDIR
DIR22
SSDIR
03456
04190
05012
05742
];
this is output