a EXCEL template for Batch input data to BI report the Query Panel
Sometime, For example,Batch input ProductS ID when you query data,
input SO many ProductS ID are random,One by one … so… Crazy!
Now i made a EXCEL template for Batch input data.
Manufacturing template method:
step 1 cell A2 input “d2&”,and Pull down to rows 1501
step 2 copy cells “A2:A1501” TO TXT file, then copy the data in TXT to WORD
step 3 replace “^p” to nothing in WORD,and del last “&”,COPY THE DATA TO CELL D1503
step 4 cell C2 input formula: =IF(B2=””,””,REPT(“0”,$B$1-LEN(B2))&B2) ,and pull down 1501
step 5 cell D2 input formula: =IF(C2=””,””,IF(C3=””,C2&””,C2&”;”)) ,and pull down 1501
copy cell D1503 to BI report the Query Panel,and Attention:delete The trailing space OF last ID
Hope that helps,
wang
Be the first to leave a comment
You must be Logged on to comment or reply to a post.