Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I'm loading data in Sense using basic script and have 2 issues:
1. I need to merge columns. For example in Excel it looks like "ABC" and "DEF" columns, and after loading I need the only column "ABCDEF". I'm trying to do the next:
LOAD Column1 & Column2 as Column3
But I get double data in a table like this "ABCDEFDEF". Could anyboby explain me my mistake?
2. After loading I need to delete some special symbols in a string. For example make "ABC!!DEF" to "ABCDEF" removing those exclamation marks.
Any suggestions please?
Hi Maxsugak,
For the first one:
I think normally you will get "ABCDEF" value in column3, if possible, it's better to share a small sample of your data, so I can check the reason that why you get "ABCDEFDEF" in column3.
For the second question:
You can use PurgeChar() function, in your example, like : = PurgeChar(Column3,'!')
Aiolos Zhao
Hi Maxsugak,
For the first one:
I think normally you will get "ABCDEF" value in column3, if possible, it's better to share a small sample of your data, so I can check the reason that why you get "ABCDEFDEF" in column3.
For the second question:
You can use PurgeChar() function, in your example, like : = PurgeChar(Column3,'!')
Aiolos Zhao