Fact:
Load * Inline
[ ProductID , ProductName
1 , A1/A2/A3
2 , B1/B2/B3/B4
3 , C1/C2
] ;
Dim:
Load ProductID ,
SubField( ProductName,'/') AS NewProductName
Resident Fact;
效果
Fact:
Load * Inline
[ ProductID , ProductName
1 , A1/A2/A3
2 , B1/B2/B3/B4
3 , C1/C2
] ;
Dim:
Load ProductID ,
SubField( ProductName,'/') AS NewProductName
Resident Fact;
效果
本文标题:QlikView -分隔字符串- SubField
本文链接:https://www.haomeiwen.com/subject/ctlajftx.html
网友评论