Mindmajix

CREATE A MACRO TO FILTER MULTILINGUAL ROWS:

CREATE A MACRO TO FILTER MULTILINGUAL ROWS:

You can go through Create a macro to modify multi lingual columns before learning how to create a macro to filter multilingual rows.

  • From SALES namespace
  • Select country_multilingual query subject
  • Click on Edit definition
  • From SQL pane
  • Delete default SQL query
  • Expand gosl
  • Select country_multilingual
  • Select all query items
  • Drop on SQL pane
  • Define the where clause with the following syntax
  • Where country_multilingual“language”=insert macro
  • From toolbar
  • Click on single quote button
  • Click on test tab
  • Click on test sample
  • Click on OK

Screenshot_252

Screenshot_253

Screenshot_254

Screenshot_255

http://ibm.co/1rIZtV5


 

0 Responses on CREATE A MACRO TO FILTER MULTILINGUAL ROWS:"

Leave a Message

Your email address will not be published. Required fields are marked *

Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.