Versions Compared

Old Version 11

changes.mady.by.user Polly Tan

Saved on

compared with

New Version 12

changes.mady.by.user Polly Tan

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

JIRA

SUMMARY

DESCRIPTION

DETAILS

ORG-26738

Sort Alluvial Node by Frequency

We can sort Alluvial node by name/ frequency.

In Node tab, add Node Order by option above Gap between Nodes. dropdown could be

  • None: current way, order of data, or categorical order

  • Name: alphabetical order

  • Frequency: frequency of node in column

ORG-27027

XF to Create Multiple VM and Plot Heatmap

A new dialog: plotmultivm to create heatmap with multiple info in one cell.

Command line usage for Existing Virtual Matrices type:

plotmultivm datatype:=vm irng:=VM1|VM2;

Import

JIRA

SUMMARY

DESCRIPTION

DETAILS

ORG-26952

CSV connector failed to keep Text type column format

Added a system variable @IPKF to control which column format would be kept after import.

The @IPKF system variable is for CSV Connector only.

  • 0(default): keep date/time column format

  • 1: keep date/time/Text column format

  • -1: keep any column format

ORG-26921

CSV Connector supports append rows from script

CSV Connector supports append rows to import more files by scripts.

LT sample scripts:

Code Block
newbook;
string fname, path$=system.path.program$ + "Samples\Batch Processing\"; 
findfiles fname:=fname$ ext:="*.csv";
int num = fname.GetNumTokens(CRLF);
wbook.dc.add("CSV");
loop(ii,1,num)
{
next$ = fname.GetToken(ii, CRLF)$;
if (ii==1)
{
	wks.dc.flags=256;	// turn on append rows mode
}
wks.dc.source$=next$;
Tree tr1=wks.dc.optn$;
tr1.settings.partial.SetAttribute("Use", 1);
tr1.settings.partial.row$="2";
tr1.ToString(wks.dc.optn$);
wks.dc.import();
}

...