Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
Hi Friends,
In a text file i have lot of transactions eg: 9220 .each line contains 256 bytes
each transaction contains 2 or 3 or 4 or 5 or 6......so many lines.
Now i want to load this text file into QlikView, but each and every line they are split into according to their requirement i.e 9220 is the starting of the transaction and 9221,9222,9223,9223,9240 lines are comes under 9220 transaction only.
 
 
					
				
		
 sinanozdemir
		
			sinanozdemir
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Maybe something like this:
And then datamodel looks like this:
Hope this helps.
 
					
				
		
 rwunderlich
		
			rwunderlich
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Take a look at this example to see if is what you are looking for:
Qlikview Cookbook: Load Input File Containing Multiple Record Types http://qlikviewcookbook.com/recipes/download-info/load-input-file-containing-multiple-record-types/
