Discussion board where members can get started with QlikView.
We need to trim field based on some conditions as below.
Please find the attached spreadsheet for more detail reference.
LOAD SubField(F1, '_', 1) * 1 as Expected1,
SubField(F2, '_', 2) as Expected2,
LOAD * INLINE [
View solution in original post
What are the C,F,H ??
May be look SubField() function ?
These were the prefix for the ID's.
The motive is to get both supplierId's from two different sources into one format.
That means you have 2 fields already. So SubField() works for you?? Look in help
Maybe try 'Mid' function:
mid(FieldName,StartNum,EndNum) as NewValue
mid([Supplier ID], 5, 10) as New Value
I hope that helps.