Export to Excel with dynamic Category

  • Updated

This Action Map exports Perfion data to an Excel-file using a Category value set as a variable in the Action Map. 

This example is provided as inspiration only. It must be adapted to your Perfion environment to work. Perfion Support does not assist with such adaptations. Please contact your Perfion Partner or your Perfion consultant if you need assistance.

Action Map

  • All lines containing a Command are created as virtuals. This is a recommended best practice
  • The dynamic Catagory value is assigned to $Cat in line 1-2 using at SET command 
  • The "." in line 3 field means "current Perfion database"

Sample data for building Action Map

NOTE: Line breaks are omitted if you paste scripts from the table below directly to an action. In stead, paste script to Notepad++ and then copy from there. That will preserve line breaks when you paste into an action.

Action Map - FromToCommandActionScriptNote
 QuerySET   
Pots and pans$Cat    
.CoffeeDataSELECT.PERFION <Query>
<Select languages='EN'>
<Feature id='*' view='Config' />
</Select>
<From id ='100'/>
<Where>
<Clause id='Brand' operator='=' value='Normal' />
<Clause id='Category' operator='=' value='{=$Cat}' />
</Where>
</Query>		 
table@FORMAT    
CoffeeDataCoffeeSELECT   
_ValueItemNumber    
BrandNameBrand    
EANCodeEAN    
ItemName_ENName    
Category_ENCategory    
CoffeeC:\Perfion Data\ActionSources\Export\Coffeedata.xlsxWRITE.EXCEL   

Was this article helpful?

0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.